SyOrganization

Logical Entity Name | SyOrganization
Default Table Name | SyOrganization
Physical Only | NO
Owner | dbo
Definition |
Note |

SyOrganization Columns

ColumnName | Domain | Datatype | NULL | Definition
SyOrganizationID |  | int | NO |
Code |  | char(16) | NO |
Descrip |  | varchar(60) | NO |
Address |  | varchar(255) | YES |
City |  | char(35) | YES |
State |  | char(2) | YES |
ZIP |  | char(10) | YES |
SyCountryID |  | int | YES |
Phone |  | varchar(16) | YES |
Fax |  | varchar(16) | YES |
Comments |  | varchar(2000) | YES |
Active |  | bit | NO |
SyCountyID |  | int | YES |
Email |  | varchar(50) | YES |
URL |  | varchar(50) | YES |
SyOrganizationTypeID |  | int | NO |
SyCampusGrpID |  | int | YES |
OrgLiaisionId |  | int | YES |
UserId |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
TS |  | timestamp | NO |
CrmSuppressFlag |  | bit | NO |

SyOrganization Primary and Unique Keys

Key Name | Key Type | Keys
PK_SyOrganization_SyOrganizationID | PrimaryKey | SyOrganizationID

SyOrganization Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SyOrganization_OrgLiaisionId_SyStaff_SyStaffid |  |  | OrgLiaisionId | NO | YES
SyCampusGrp | Non-Identifying | Zero or One to Zero or More | FK_SyOrganization_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  | SyCampusGrpID | NO | YES
SyCountry | Non-Identifying | Zero or One to Zero or More | FK_SyOrganization_SyCountryID_SyCountry_SyCountryID |  |  | SyCountryID | NO | YES
SyCounty | Non-Identifying | Zero or One to Zero or More | FK_SyOrganization_SyCountyID_SyCounty_SyCountyID |  |  | SyCountyID | NO | YES
SyOrganizationType | Non-Identifying | One To Zero or More | FK_SyOrganization_SyOrganizationTypeID_SyOrganizationType_SyOrganizationTypeID |  |  | SyOrganizationTypeID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SyOrganization_UserId_SyStaff_SyStaffID |  |  | UserId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AmHighSchool | Non-Identifying | One To Zero or More | FK_AmHighSchool_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
AmLeadExpense | Non-Identifying | One To Zero or More | FK_AmLeadExpense_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
AmLeadSrcLeadVendor | Non-Identifying | One To Zero or More | FK_AmLeadSrcLeadVendor_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
AmLeadVendor | Non-Identifying | One To Zero or More | FK_AmLeadVendor_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
AmLeadVendorRelationship | Non-Identifying | One To Zero or More | FK_AmLeadVendorRelationship_ParentSyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
AmLeadVendorRelationship | Non-Identifying | One To Zero or More | FK_AmLeadVendorRelationship_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
AmProspectLeadSrcLeadVendor | Non-Identifying | One To Zero or More | FK_AmProspectLeadSrcLeadVendor_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
CmEvent | Non-Identifying | One To Zero or More | FK_CmEvent_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
CmEventHistory_ro | Non-Identifying | One To Zero or More | FK_CmEventHistory_ro_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
SyOrganizationContact | Non-Identifying | One To Zero or More | FK_SyOrganizationContact_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES
SyStudentOrganizationContact | Non-Identifying | One To Zero or More | FK_SyStudentOrganizationContact_SyOrganizationID_SyOrganization_SyOrganizationID |  |  |  | NO | YES

SyOrganization Check Constraints

Check Constraint Name | CheckConstraint

SyOrganization Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SyOrganization Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyOrganization | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyOrganization | NO |  |  |

SyOrganization Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyOrganization Data Movement Rules

Name | Type | Rule Text/Value